DROP TABLE IF EXISTS "public"."user" CASCADE;
BEGIN;
CREATE TABLE "public"."user" (
  username VARCHAR(255) PRIMARY KEY,
  password VARCHAR(255) NOT NULL,
  permission INT NOT NULL
);
COMMIT;

BEGIN;
CREATE TABLE "public"."key" (
  kid SERIAL PRIMARY KEY,
  val VARCHAR(255) NOT NULL
);
COMMIT;